Entrée [1]:
Entrée [2]:
Entrée [3]:
Entrée [4]:
Entrée [5]:
Entrée [6]:
Entrée [7]:
Entrée [8]:
Entrée [9]:
Found existing installation: holidays 0.11.1
Uninstalling holidays-0.11.1:
  Successfully uninstalled holidays-0.11.1
Collecting holidays
  Downloading holidays-0.35-py3-none-any.whl (800 kB)
     ---------------------------------------- 0.0/801.0 kB ? eta -:--:--
     ------------- ------------------------ 286.7/801.0 kB 8.9 MB/s eta 0:00:01
     ----------------------------- -------- 614.4/801.0 kB 6.4 MB/s eta 0:00:01
     -------------------------------------  798.7/801.0 kB 6.3 MB/s eta 0:00:01
     -------------------------------------- 801.0/801.0 kB 4.2 MB/s eta 0:00:00
Requirement already satisfied: python-dateutil in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays) (2.8.2)
Requirement already satisfied: six>=1.5 in c:\users\vuseghesa\miniconda3\lib\site-packages (from python-dateutil->holidays) (1.16.0)
Installing collected packages: holidays
Successfully installed holidays-0.35
Entrée [10]:
Requirement already satisfied: holidays in c:\users\vuseghesa\miniconda3\lib\site-packages (0.35)
Requirement already satisfied: python-dateutil in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays) (2.8.2)
Requirement already satisfied: six>=1.5 in c:\users\vuseghesa\miniconda3\lib\site-packages (from python-dateutil->holidays) (1.16.0)
Entrée [11]:
Collecting holidays==0.11.1
  Using cached holidays-0.11.1-py3-none-any.whl (133 kB)
Requirement already satisfied: hijri-converter in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (2.3.1)
Requirement already satisfied: python-dateutil in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (2.8.2)
Requirement already satisfied: six in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (1.16.0)
Requirement already satisfied: convertdate>=2.3.0 in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (2.4.0)
Requirement already satisfied: korean-lunar-calendar in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (0.3.1)
Requirement already satisfied: pymeeus<=1,>=0.3.13 in c:\users\vuseghesa\miniconda3\lib\site-packages (from convertdate>=2.3.0->holidays==0.11.1) (0.5.12)
Installing collected packages: holidays
  Attempting uninstall: holidays
    Found existing installation: holidays 0.35
    Uninstalling holidays-0.35:
      Successfully uninstalled holidays-0.35
Successfully installed holidays-0.11.1
Entrée [12]:
Requirement already satisfied: plotly in c:\users\vuseghesa\miniconda3\lib\site-packages (5.15.0)
Requirement already satisfied: tenacity>=6.2.0 in c:\users\vuseghesa\miniconda3\lib\site-packages (from plotly) (8.2.2)
Requirement already satisfied: packaging in c:\users\vuseghesa\miniconda3\lib\site-packages (from plotly) (23.0)
Note: you may need to restart the kernel to use updated packages.
Entrée [13]:
Entrée [14]:
Entrée [15]:
Entrée [16]:
Entrée [17]:
Entrée [18]:
IOT-temp.csv : (97606, 5)
Out[18]:
id room_id/id noted_date temp out/in
0 __export__.temp_log_196134_bd201015 Room Admin 08-12-2018 09:30 29 In
1 __export__.temp_log_196131_7bca51bc Room Admin 08-12-2018 09:30 29 In
2 __export__.temp_log_196127_522915e3 Room Admin 08-12-2018 09:29 41 Out
Entrée [19]:
Out[19]:
id room_id/id noted_date temp out/in outside inside
0 __export__.temp_log_196134_bd201015 Room Admin 08-12-2018 09:30 29 In 1 0
1 __export__.temp_log_196131_7bca51bc Room Admin 08-12-2018 09:30 29 In 1 0
2 __export__.temp_log_196127_522915e3 Room Admin 08-12-2018 09:29 41 Out 0 1
3 __export__.temp_log_196128_be0919cf Room Admin 08-12-2018 09:29 41 Out 0 1
4 __export__.temp_log_196126_d30b72fb Room Admin 08-12-2018 09:29 31 In 1 0
Entrée [20]:
Out[20]:
id room_id/id date temp place outside inside
0 __export__.temp_log_196134_bd201015 Room Admin 08-12-2018 09:30 29 In 1 0
1 __export__.temp_log_196131_7bca51bc Room Admin 08-12-2018 09:30 29 In 1 0
2 __export__.temp_log_196127_522915e3 Room Admin 08-12-2018 09:29 41 Out 0 1
Entrée [21]:
Index(['id', 'room_id/id', 'date', 'temp', 'place', 'outside', 'inside'], dtype='object')
Entrée [22]:
Entrée [23]:
Les valeurs 'In' sont :  20345
Les valeurs 'Out' sont :  77261
Les valeurs '29' sont :  7922
Entrée [24]:
Out[24]:
pandas.core.series.Series
Entrée [25]:
Out[25]:
Text(0.5, 1.0, 'place v/s Temp')
Entrée [26]:
Les valeurs '1' dans la colonne 'inside'sont :  77261
Les valeurs '1' dans la colonne 'outside'sont :  20345
Entrée [27]:
Entrée [28]:
Entrée [29]:
Les noeuds pris aléatoirement sont au nombre de :  30854
Entrée [30]:
Pourcentage noeud selectionnés :  31.610761633506137
Entrée [31]:
Entrée [32]:
Entrée [33]:
Out[33]:
Room Admin    97606
Name: room_id/id, dtype: int64
Entrée [34]:
Les valeurs '29' dans la colonne 'temp'sont :  2500
Les valeurs 'Out' dans la colonne 'place'sont :  24411
Les valeurs 'In' dans la colonne 'Place'sont :  6443
Les valeurs '1' dans la colonne 'outside'sont :  6443
Les valeurs '1' dans la colonne 'outside'sont :  24411
Entrée [35]:
                                        id  room_id/id              date  \
0      __export__.temp_log_196134_bd201015  Room Admin  08-12-2018 09:30   
1      __export__.temp_log_196131_7bca51bc  Room Admin  08-12-2018 09:30   
2      __export__.temp_log_196127_522915e3  Room Admin  08-12-2018 09:29   
3      __export__.temp_log_196128_be0919cf  Room Admin  08-12-2018 09:29   
4      __export__.temp_log_196126_d30b72fb  Room Admin  08-12-2018 09:29   
...                                    ...         ...               ...   
97601   __export__.temp_log_91076_7fbd08ca  Room Admin  28-07-2018 07:07   
97602  __export__.temp_log_147733_62c03f31  Room Admin  28-07-2018 07:07   
97603  __export__.temp_log_100386_84093a68  Room Admin  28-07-2018 07:06   
97604  __export__.temp_log_123297_4d8e690b  Room Admin  28-07-2018 07:06   
97605  __export__.temp_log_133741_32958703  Room Admin  28-07-2018 07:06   

       temp place  outside  inside  
0        87    In        1       0  
1        87    In        1       0  
2        41   Out        0       1  
3        41   Out        0       1  
4        31    In        1       0  
...     ...   ...      ...     ...  
97601    31    In        1       0  
97602    31    In        1       0  
97603    31    In        1       0  
97604    31    In        1       0  
97605    31    In        1       0  

[97606 rows x 7 columns]
Entrée [36]:
Out[36]:
Room Admin    97606
Name: room_id/id, dtype: int64
Entrée [37]:
Out[37]:
id date temp place outside inside
0 __export__.temp_log_196134_bd201015 08-12-2018 09:30 87 In 1 0
1 __export__.temp_log_196131_7bca51bc 08-12-2018 09:30 87 In 1 0
2 __export__.temp_log_196127_522915e3 08-12-2018 09:29 41 Out 0 1
Entrée [38]:
Out[38]:
id date temp place outside inside
0 __export__.temp_log_196134_bd201015 08-12-2018 09:30 87 In 1 0
1 __export__.temp_log_196131_7bca51bc 08-12-2018 09:30 87 In 1 0
2 __export__.temp_log_196127_522915e3 08-12-2018 09:29 41 Out 0 1
Entrée [39]:
Out[39]:
id date temp place outside inside year month day weekday weekofyear hour minute
0 __export__.temp_log_196134_bd201015 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30
1 __export__.temp_log_196131_7bca51bc 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30
2 __export__.temp_log_196127_522915e3 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29
Entrée [40]:
Entrée [41]:
Out[41]:
id date temp place outside inside year month day weekday weekofyear hour minute season
0 __export__.temp_log_196134_bd201015 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30 Winter
1 __export__.temp_log_196131_7bca51bc 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30 Winter
2 __export__.temp_log_196127_522915e3 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29 Winter
Entrée [42]:
Entrée [43]:
Out[43]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
0 __export__.temp_log_196134_bd201015 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
1 __export__.temp_log_196131_7bca51bc 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
2 __export__.temp_log_196127_522915e3 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29 Winter Morning
Entrée [44]:
Entrée [45]:
Out[45]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
10 __export__.temp_log_196108_4a983c7e 2018-12-08 09:25:00 42 Out 0 1 2018 12 8 Saturday 49 9 25 Winter Morning
11 __export__.temp_log_196108_4a983c7e 2018-12-08 09:25:00 42 Out 0 1 2018 12 8 Saturday 49 9 25 Winter Morning
Entrée [46]:
Entrée [47]:
Out[47]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
61229 __export__.temp_log_101144_ff2f0b97 2018-09-12 03:09:00 87 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61258 __export__.temp_log_101502_172517d2 2018-09-12 03:09:00 87 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
61255 __export__.temp_log_104868_a5e526b3 2018-09-12 03:09:00 28 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
61231 __export__.temp_log_108845_062b2592 2018-09-12 03:09:00 28 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
61272 __export__.temp_log_112303_fca608f4 2018-09-12 03:09:00 87 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
Entrée [48]:
Out[48]:
False
Entrée [49]:
Out[49]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
0 196134 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
1 196131 2018-12-08 09:30:00 87 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
2 196127 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29 Winter Morning
Entrée [50]:
Out[50]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
61273 17002 2018-09-12 03:09:00 87 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61275 17003 2018-09-12 03:09:00 28 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61267 17006 2018-09-12 03:09:00 28 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61269 17009 2018-09-12 03:09:00 28 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61271 17010 2018-09-12 03:09:00 87 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
Entrée [51]:
Out[51]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
84141 4000 2018-09-09 16:24:00 87 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84142 4002 2018-09-09 16:24:00 87 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84144 4004 2018-09-09 16:23:00 28 Out 0 1 2018 9 9 Sunday 36 16 23 Monsoon Afternoon
84128 4006 2018-09-09 16:24:00 28 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84132 4007 2018-09-09 16:24:00 87 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84136 4009 2018-09-09 16:24:00 28 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84137 4010 2018-09-09 16:24:00 28 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
Entrée [52]:
Out[52]:
Entrée [53]:
Out[53]:
Entrée [54]:
Out[54]:
Entrée [55]:
Out[55]:
Entrée [56]:
Out[56]:
Entrée [57]:
Out[57]:
Entrée [58]:
Out[58]:
Entrée [59]:
Out[59]:
Entrée [60]:
Out[60]:
Entrée [61]:
Out[61]:
date temp place outside inside year month day weekday weekofyear hour minute season timing
0 2018-07-28 07:06:00 31.0 In 1 0 2018 7 28 Saturday 30 7 6 Monsoon Morning
1 2018-07-28 07:07:00 31.0 Out 0 1 2018 7 28 Saturday 30 7 7 Monsoon Morning
2 2018-07-28 07:07:00 32.0 In 1 0 2018 7 28 Saturday 30 7 7 Monsoon Morning
Entrée [62]:
Out[62]:
Entrée [63]:
Out[63]:
Entrée [64]:
Out[64]:
Entrée [65]:
Out[65]:
Entrée [66]:
Out[66]:
Entrée [67]:
Out[67]:
Entrée [68]:
Out[68]:
daily In Out season_Monsoon season_Post_Monsoon season_Winter
0 2018-07-28 31.142857 31.691667 1 0 0
1 2018-07-29 32.500000 31.333333 1 0 0
2 2018-07-30 31.227159 41.015761 1 0 0
Entrée [70]:
Entrée [71]:
Out[71]:
Text(0.5, 1.0, 'Place v/s Temp')
Entrée [72]:
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_15656\2971206133.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_15656\2971206133.py:41: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig2.show()
Entrée [73]:
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_15656\2971206133.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_15656\2971206133.py:41: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig2.show()
Entrée [74]:
Out[74]:
Entrée [75]:
Out[75]:
Entrée [74]:
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_15656\2971206133.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_15656\2971206133.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
Entrée [ ]: